package com.lt.test.provider.mapper;

import com.lt.test.entity.DTO.OrderPayInfoDTO;
import com.lt.test.entity.DTO.SPLOrderDTO;
import com.lt.test.entity.QueryModel.PageQueryModel;

import java.util.List;
import java.util.Map;

/**
 * Created by zhengchuan on 2017/3/14.
 */
public interface SPLOrderMapper {
    /**
     * 分页查询烟草客户订单信息
     * @param pagequeryModel
     * @return
     * @throws Exception
     */
    List<SPLOrderDTO> findSPLOrderByPage(PageQueryModel pagequeryModel) throws Exception;
    /**
     * 查询烟草客户订单总数
     * @param pageQueryModel
     * @return
     */
    int getSPLOrderCount(PageQueryModel pageQueryModel) throws Exception;

    /**
     * 烟草客户订单信息
     * @param orderId
     * @return
     */
    List<OrderPayInfoDTO> getPayInfo(String orderId) throws Exception;

    /**
     * 获取最新的十条订单信息
     * @return
     */
    List<SPLOrderDTO> findTenSPLOrder(Map<String, String> params) throws Exception;

    /**
     *根据最后更新时间获取订单
     * @param params
     * @return
     * @throws Exception
     */
    List<SPLOrderDTO> findSPLOrderByLastOrderTime(Map<String, String> params) throws Exception;

    List<Map<String,Object>> findSPLOrderDayData(Map<String, String> params) throws Exception;


    List<Map<String,Object>> findSPLOrderMonthData(Map<String, String> params) throws Exception;

    List<Map<String,Object>> findSPLOrderYearData(Map<String, String> params) throws Exception;

    List<SPLOrderDTO> getOrderByBeginTimeAndEndTime(Map<String, String> params) throws Exception;

    String getEmpCodeByEmpName(String empName) throws Exception;

    String getIdByChannleName(String quXianName)  throws Exception;

    List<String>  getChannelIdsByQuXianId(String quXianId);

    List<Map<String,String>> findSPLOrderStatisticsData(Map<String, String> stringMap);

    List<Map<String,String>> findSPLOrderByPageM(Map<String, String> stringMap);

    int getSPLOrderCountM(Map<String, String> stringMap);
}
